package com.cyf.db.mapper.smartCity;

import com.cyf.db.bean.LocalIct;
import com.cyf.smartCity.bean.WechatParkReportReq;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface LocalIctMapper {

    @Select("select sum(actualFee) as  actualFee ,sum(changeAmount) as  changeAmount,parkingId " +
            "from local_ict where " +
            "parkingId = #{req.parkingId} and  createdTime >= '${req.searchDate} 00:00:00' " +
            "and createdTime < '${req.searchDate} 23:59:59'")
    LocalIct selectIctByTime(@Param("req")WechatParkReportReq req);

}
